/*
 * $Id: ProgrammeCodeDao.java 3 2011-12-26 07:48:43Z forwardly@hotmail.com $
 * 
 * Copyright (c) 2001-2008 Accentrix Company Limited. All Rights Reserved.
 * 
 * Accentrix Company Limited. ("Accentrix") retains copyright on all text, source
 * and binary code contained in this software and documentation. Accentrix grants
 * Licensee a limited license to use this software, provided that this copyright
 * notice and license appear on all copies of the software. The software source
 * code is provided for reference purposes only and may not be copied, modified 
 * or distributed.
 * 
 * THIS SOFTWARE AND DOCUMENTATION ARE PROVIDED "AS IS," WITHOUT ANY WARRANTY OF
 * ANY KIND UNLESS A SEPARATE WARRANTIES IS PURCHASED FROM ACCENTRIX AND REMAINS
 * VALID.  ALL EXPRESS OR IMPLIED CONDITIONS, REPRESENTATIONS AND WARRANTIES,
 * INCLUDING ANY IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR
 * PURPOSE OR NON-INFRINGEMENT, ARE HEREBY EXCLUDED. ACCENTRIX SHALL NOT BE LIABLE
 * FOR ANY DAMAGES SUFFERED BY LICENSEE AS A RESULT OF USING OR MODIFYING THE
 * SOFTWARE OR ITS DERIVATIVES.
 * 
 * IN NO EVENT WILL ACCENTRIX BE LIABLE FOR ANY LOST REVENUE, PROFIT OR DATA, OR
 * FOR DIRECT, INDIRECT, SPECIAL, CONSEQUENTIAL, INCIDENTAL OR PUNITIVE DAMAGES,
 * HOWEVER CAUSED AND REGARDLESS OF THE THEORY OF LIABILITY, ARISING OUT OF THE
 * USE OF OR INABILITY TO USE SOFTWARE, EVEN IF ACCENTRIX HAS BEEN ADVISED OF THE
 * POSSIBILITY OF SUCH DAMAGES.
 */
package com.lightsaber.trade.as.dao.programme;

import java.util.HashMap;
import java.util.Map;

import org.apache.commons.lang.xwork.StringUtils;
import org.springframework.stereotype.Component;
import org.springside.modules.orm.Page;

import com.lightsaber.trade.as.entity.programme.ProgrammeCode;
import com.lightsaber.trade.core.dao.BaseDao;

@Component
public class ProgrammeCodeDao extends BaseDao<ProgrammeCode, String> {

    public ProgrammeCode getByCode(final String code) {
        eq("code", code);
        return unique();
    }

    public Page<ProgrammeCode> findUseableCodes(final String code,
            final Page<ProgrammeCode> useableCodepage, String searchCode) {
        String andSearchCode = "";
        if (StringUtils.isNotBlank(searchCode)) {
            andSearchCode = "and cd.code like :searchCode";
        }

        String hql = "select cd from ProgrammeCode cd where not exists "
                + "(select 1 from SubjectGroup gp, SubjectGroupItem gpi "
                + "where gpi.subjectGroup=gp and gp.programmeCode.code<>:code and (cd.code=gp.programmeCode.code or cd.code=gpi.programmeCode.code)) "
                + "and cd.code<>:code " + andSearchCode + " order by cd.code asc";

        Map<String, String> params = new HashMap<String, String>();
        params.put("code", code);

        if (StringUtils.isNotBlank(searchCode)) {
            params.put("searchCode", "%" + searchCode + "%");
        }

        return findPage(useableCodepage, hql, params);
    }
}
